package com.desksoft.ecommerce.entity.logistics.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class StoreExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public StoreExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorenameIsNull() {
            addCriterion("StoreName is null");
            return (Criteria) this;
        }

        public Criteria andStorenameIsNotNull() {
            addCriterion("StoreName is not null");
            return (Criteria) this;
        }

        public Criteria andStorenameEqualTo(String value) {
            addCriterion("StoreName =", value, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameNotEqualTo(String value) {
            addCriterion("StoreName <>", value, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameGreaterThan(String value) {
            addCriterion("StoreName >", value, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameGreaterThanOrEqualTo(String value) {
            addCriterion("StoreName >=", value, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameLessThan(String value) {
            addCriterion("StoreName <", value, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameLessThanOrEqualTo(String value) {
            addCriterion("StoreName <=", value, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameLike(String value) {
            addCriterion("StoreName like", value, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameNotLike(String value) {
            addCriterion("StoreName not like", value, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameIn(List<String> values) {
            addCriterion("StoreName in", values, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameNotIn(List<String> values) {
            addCriterion("StoreName not in", values, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameBetween(String value1, String value2) {
            addCriterion("StoreName between", value1, value2, "storename");
            return (Criteria) this;
        }

        public Criteria andStorenameNotBetween(String value1, String value2) {
            addCriterion("StoreName not between", value1, value2, "storename");
            return (Criteria) this;
        }

        public Criteria andPycodeIsNull() {
            addCriterion("PYCode is null");
            return (Criteria) this;
        }

        public Criteria andPycodeIsNotNull() {
            addCriterion("PYCode is not null");
            return (Criteria) this;
        }

        public Criteria andPycodeEqualTo(String value) {
            addCriterion("PYCode =", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotEqualTo(String value) {
            addCriterion("PYCode <>", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeGreaterThan(String value) {
            addCriterion("PYCode >", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeGreaterThanOrEqualTo(String value) {
            addCriterion("PYCode >=", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLessThan(String value) {
            addCriterion("PYCode <", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLessThanOrEqualTo(String value) {
            addCriterion("PYCode <=", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLike(String value) {
            addCriterion("PYCode like", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotLike(String value) {
            addCriterion("PYCode not like", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeIn(List<String> values) {
            addCriterion("PYCode in", values, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotIn(List<String> values) {
            addCriterion("PYCode not in", values, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeBetween(String value1, String value2) {
            addCriterion("PYCode between", value1, value2, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotBetween(String value1, String value2) {
            addCriterion("PYCode not between", value1, value2, "pycode");
            return (Criteria) this;
        }

        public Criteria andChairmanIsNull() {
            addCriterion("Chairman is null");
            return (Criteria) this;
        }

        public Criteria andChairmanIsNotNull() {
            addCriterion("Chairman is not null");
            return (Criteria) this;
        }

        public Criteria andChairmanEqualTo(String value) {
            addCriterion("Chairman =", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotEqualTo(String value) {
            addCriterion("Chairman <>", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanGreaterThan(String value) {
            addCriterion("Chairman >", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanGreaterThanOrEqualTo(String value) {
            addCriterion("Chairman >=", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLessThan(String value) {
            addCriterion("Chairman <", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLessThanOrEqualTo(String value) {
            addCriterion("Chairman <=", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLike(String value) {
            addCriterion("Chairman like", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotLike(String value) {
            addCriterion("Chairman not like", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanIn(List<String> values) {
            addCriterion("Chairman in", values, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotIn(List<String> values) {
            addCriterion("Chairman not in", values, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanBetween(String value1, String value2) {
            addCriterion("Chairman between", value1, value2, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotBetween(String value1, String value2) {
            addCriterion("Chairman not between", value1, value2, "chairman");
            return (Criteria) this;
        }

        public Criteria andSquareIsNull() {
            addCriterion("Square is null");
            return (Criteria) this;
        }

        public Criteria andSquareIsNotNull() {
            addCriterion("Square is not null");
            return (Criteria) this;
        }

        public Criteria andSquareEqualTo(Integer value) {
            addCriterion("Square =", value, "square");
            return (Criteria) this;
        }

        public Criteria andSquareNotEqualTo(Integer value) {
            addCriterion("Square <>", value, "square");
            return (Criteria) this;
        }

        public Criteria andSquareGreaterThan(Integer value) {
            addCriterion("Square >", value, "square");
            return (Criteria) this;
        }

        public Criteria andSquareGreaterThanOrEqualTo(Integer value) {
            addCriterion("Square >=", value, "square");
            return (Criteria) this;
        }

        public Criteria andSquareLessThan(Integer value) {
            addCriterion("Square <", value, "square");
            return (Criteria) this;
        }

        public Criteria andSquareLessThanOrEqualTo(Integer value) {
            addCriterion("Square <=", value, "square");
            return (Criteria) this;
        }

        public Criteria andSquareIn(List<Integer> values) {
            addCriterion("Square in", values, "square");
            return (Criteria) this;
        }

        public Criteria andSquareNotIn(List<Integer> values) {
            addCriterion("Square not in", values, "square");
            return (Criteria) this;
        }

        public Criteria andSquareBetween(Integer value1, Integer value2) {
            addCriterion("Square between", value1, value2, "square");
            return (Criteria) this;
        }

        public Criteria andSquareNotBetween(Integer value1, Integer value2) {
            addCriterion("Square not between", value1, value2, "square");
            return (Criteria) this;
        }

        public Criteria andEmployeeIsNull() {
            addCriterion("Employee is null");
            return (Criteria) this;
        }

        public Criteria andEmployeeIsNotNull() {
            addCriterion("Employee is not null");
            return (Criteria) this;
        }

        public Criteria andEmployeeEqualTo(Integer value) {
            addCriterion("Employee =", value, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeNotEqualTo(Integer value) {
            addCriterion("Employee <>", value, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeGreaterThan(Integer value) {
            addCriterion("Employee >", value, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("Employee >=", value, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeLessThan(Integer value) {
            addCriterion("Employee <", value, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeLessThanOrEqualTo(Integer value) {
            addCriterion("Employee <=", value, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeIn(List<Integer> values) {
            addCriterion("Employee in", values, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeNotIn(List<Integer> values) {
            addCriterion("Employee not in", values, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeBetween(Integer value1, Integer value2) {
            addCriterion("Employee between", value1, value2, "employee");
            return (Criteria) this;
        }

        public Criteria andEmployeeNotBetween(Integer value1, Integer value2) {
            addCriterion("Employee not between", value1, value2, "employee");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("PostCode is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("PostCode is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("PostCode =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("PostCode <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("PostCode >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("PostCode >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("PostCode <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("PostCode <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("PostCode like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("PostCode not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("PostCode in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("PostCode not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("PostCode between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("PostCode not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNull() {
            addCriterion("Telephone is null");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNotNull() {
            addCriterion("Telephone is not null");
            return (Criteria) this;
        }

        public Criteria andTelephoneEqualTo(String value) {
            addCriterion("Telephone =", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotEqualTo(String value) {
            addCriterion("Telephone <>", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThan(String value) {
            addCriterion("Telephone >", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("Telephone >=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThan(String value) {
            addCriterion("Telephone <", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThanOrEqualTo(String value) {
            addCriterion("Telephone <=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLike(String value) {
            addCriterion("Telephone like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotLike(String value) {
            addCriterion("Telephone not like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneIn(List<String> values) {
            addCriterion("Telephone in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotIn(List<String> values) {
            addCriterion("Telephone not in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneBetween(String value1, String value2) {
            addCriterion("Telephone between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotBetween(String value1, String value2) {
            addCriterion("Telephone not between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("Fax is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("Fax is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("Fax =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("Fax <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("Fax >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("Fax >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("Fax <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("Fax <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("Fax like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("Fax not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("Fax in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("Fax not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("Fax between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("Fax not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("Email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("Email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("Email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("Email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("Email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("Email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("Email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("Email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("Email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("Email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("Email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("Email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("Email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("Email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andLtdateIsNull() {
            addCriterion("LTDate is null");
            return (Criteria) this;
        }

        public Criteria andLtdateIsNotNull() {
            addCriterion("LTDate is not null");
            return (Criteria) this;
        }

        public Criteria andLtdateEqualTo(Date value) {
            addCriterion("LTDate =", value, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateNotEqualTo(Date value) {
            addCriterion("LTDate <>", value, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateGreaterThan(Date value) {
            addCriterion("LTDate >", value, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateGreaterThanOrEqualTo(Date value) {
            addCriterion("LTDate >=", value, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateLessThan(Date value) {
            addCriterion("LTDate <", value, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateLessThanOrEqualTo(Date value) {
            addCriterion("LTDate <=", value, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateIn(List<Date> values) {
            addCriterion("LTDate in", values, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateNotIn(List<Date> values) {
            addCriterion("LTDate not in", values, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateBetween(Date value1, Date value2) {
            addCriterion("LTDate between", value1, value2, "ltdate");
            return (Criteria) this;
        }

        public Criteria andLtdateNotBetween(Date value1, Date value2) {
            addCriterion("LTDate not between", value1, value2, "ltdate");
            return (Criteria) this;
        }

        public Criteria andCtdateIsNull() {
            addCriterion("CTDate is null");
            return (Criteria) this;
        }

        public Criteria andCtdateIsNotNull() {
            addCriterion("CTDate is not null");
            return (Criteria) this;
        }

        public Criteria andCtdateEqualTo(Date value) {
            addCriterion("CTDate =", value, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateNotEqualTo(Date value) {
            addCriterion("CTDate <>", value, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateGreaterThan(Date value) {
            addCriterion("CTDate >", value, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateGreaterThanOrEqualTo(Date value) {
            addCriterion("CTDate >=", value, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateLessThan(Date value) {
            addCriterion("CTDate <", value, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateLessThanOrEqualTo(Date value) {
            addCriterion("CTDate <=", value, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateIn(List<Date> values) {
            addCriterion("CTDate in", values, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateNotIn(List<Date> values) {
            addCriterion("CTDate not in", values, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateBetween(Date value1, Date value2) {
            addCriterion("CTDate between", value1, value2, "ctdate");
            return (Criteria) this;
        }

        public Criteria andCtdateNotBetween(Date value1, Date value2) {
            addCriterion("CTDate not between", value1, value2, "ctdate");
            return (Criteria) this;
        }

        public Criteria andSenddateIsNull() {
            addCriterion("SendDate is null");
            return (Criteria) this;
        }

        public Criteria andSenddateIsNotNull() {
            addCriterion("SendDate is not null");
            return (Criteria) this;
        }

        public Criteria andSenddateEqualTo(Date value) {
            addCriterion("SendDate =", value, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateNotEqualTo(Date value) {
            addCriterion("SendDate <>", value, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateGreaterThan(Date value) {
            addCriterion("SendDate >", value, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateGreaterThanOrEqualTo(Date value) {
            addCriterion("SendDate >=", value, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateLessThan(Date value) {
            addCriterion("SendDate <", value, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateLessThanOrEqualTo(Date value) {
            addCriterion("SendDate <=", value, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateIn(List<Date> values) {
            addCriterion("SendDate in", values, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateNotIn(List<Date> values) {
            addCriterion("SendDate not in", values, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateBetween(Date value1, Date value2) {
            addCriterion("SendDate between", value1, value2, "senddate");
            return (Criteria) this;
        }

        public Criteria andSenddateNotBetween(Date value1, Date value2) {
            addCriterion("SendDate not between", value1, value2, "senddate");
            return (Criteria) this;
        }

        public Criteria andBaladateIsNull() {
            addCriterion("BalaDate is null");
            return (Criteria) this;
        }

        public Criteria andBaladateIsNotNull() {
            addCriterion("BalaDate is not null");
            return (Criteria) this;
        }

        public Criteria andBaladateEqualTo(Date value) {
            addCriterion("BalaDate =", value, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateNotEqualTo(Date value) {
            addCriterion("BalaDate <>", value, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateGreaterThan(Date value) {
            addCriterion("BalaDate >", value, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateGreaterThanOrEqualTo(Date value) {
            addCriterion("BalaDate >=", value, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateLessThan(Date value) {
            addCriterion("BalaDate <", value, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateLessThanOrEqualTo(Date value) {
            addCriterion("BalaDate <=", value, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateIn(List<Date> values) {
            addCriterion("BalaDate in", values, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateNotIn(List<Date> values) {
            addCriterion("BalaDate not in", values, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateBetween(Date value1, Date value2) {
            addCriterion("BalaDate between", value1, value2, "baladate");
            return (Criteria) this;
        }

        public Criteria andBaladateNotBetween(Date value1, Date value2) {
            addCriterion("BalaDate not between", value1, value2, "baladate");
            return (Criteria) this;
        }

        public Criteria andSysusedateIsNull() {
            addCriterion("SysUseDate is null");
            return (Criteria) this;
        }

        public Criteria andSysusedateIsNotNull() {
            addCriterion("SysUseDate is not null");
            return (Criteria) this;
        }

        public Criteria andSysusedateEqualTo(Date value) {
            addCriterion("SysUseDate =", value, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateNotEqualTo(Date value) {
            addCriterion("SysUseDate <>", value, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateGreaterThan(Date value) {
            addCriterion("SysUseDate >", value, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateGreaterThanOrEqualTo(Date value) {
            addCriterion("SysUseDate >=", value, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateLessThan(Date value) {
            addCriterion("SysUseDate <", value, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateLessThanOrEqualTo(Date value) {
            addCriterion("SysUseDate <=", value, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateIn(List<Date> values) {
            addCriterion("SysUseDate in", values, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateNotIn(List<Date> values) {
            addCriterion("SysUseDate not in", values, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateBetween(Date value1, Date value2) {
            addCriterion("SysUseDate between", value1, value2, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysusedateNotBetween(Date value1, Date value2) {
            addCriterion("SysUseDate not between", value1, value2, "sysusedate");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusIsNull() {
            addCriterion("SysStartStatus is null");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusIsNotNull() {
            addCriterion("SysStartStatus is not null");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusEqualTo(String value) {
            addCriterion("SysStartStatus =", value, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusNotEqualTo(String value) {
            addCriterion("SysStartStatus <>", value, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusGreaterThan(String value) {
            addCriterion("SysStartStatus >", value, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusGreaterThanOrEqualTo(String value) {
            addCriterion("SysStartStatus >=", value, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusLessThan(String value) {
            addCriterion("SysStartStatus <", value, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusLessThanOrEqualTo(String value) {
            addCriterion("SysStartStatus <=", value, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusLike(String value) {
            addCriterion("SysStartStatus like", value, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusNotLike(String value) {
            addCriterion("SysStartStatus not like", value, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusIn(List<String> values) {
            addCriterion("SysStartStatus in", values, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusNotIn(List<String> values) {
            addCriterion("SysStartStatus not in", values, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusBetween(String value1, String value2) {
            addCriterion("SysStartStatus between", value1, value2, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andSysstartstatusNotBetween(String value1, String value2) {
            addCriterion("SysStartStatus not between", value1, value2, "sysstartstatus");
            return (Criteria) this;
        }

        public Criteria andOrdersideIsNull() {
            addCriterion("OrderSide is null");
            return (Criteria) this;
        }

        public Criteria andOrdersideIsNotNull() {
            addCriterion("OrderSide is not null");
            return (Criteria) this;
        }

        public Criteria andOrdersideEqualTo(String value) {
            addCriterion("OrderSide =", value, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideNotEqualTo(String value) {
            addCriterion("OrderSide <>", value, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideGreaterThan(String value) {
            addCriterion("OrderSide >", value, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideGreaterThanOrEqualTo(String value) {
            addCriterion("OrderSide >=", value, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideLessThan(String value) {
            addCriterion("OrderSide <", value, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideLessThanOrEqualTo(String value) {
            addCriterion("OrderSide <=", value, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideLike(String value) {
            addCriterion("OrderSide like", value, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideNotLike(String value) {
            addCriterion("OrderSide not like", value, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideIn(List<String> values) {
            addCriterion("OrderSide in", values, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideNotIn(List<String> values) {
            addCriterion("OrderSide not in", values, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideBetween(String value1, String value2) {
            addCriterion("OrderSide between", value1, value2, "orderside");
            return (Criteria) this;
        }

        public Criteria andOrdersideNotBetween(String value1, String value2) {
            addCriterion("OrderSide not between", value1, value2, "orderside");
            return (Criteria) this;
        }

        public Criteria andVendororderIsNull() {
            addCriterion("VendorOrder is null");
            return (Criteria) this;
        }

        public Criteria andVendororderIsNotNull() {
            addCriterion("VendorOrder is not null");
            return (Criteria) this;
        }

        public Criteria andVendororderEqualTo(String value) {
            addCriterion("VendorOrder =", value, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderNotEqualTo(String value) {
            addCriterion("VendorOrder <>", value, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderGreaterThan(String value) {
            addCriterion("VendorOrder >", value, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderGreaterThanOrEqualTo(String value) {
            addCriterion("VendorOrder >=", value, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderLessThan(String value) {
            addCriterion("VendorOrder <", value, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderLessThanOrEqualTo(String value) {
            addCriterion("VendorOrder <=", value, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderLike(String value) {
            addCriterion("VendorOrder like", value, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderNotLike(String value) {
            addCriterion("VendorOrder not like", value, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderIn(List<String> values) {
            addCriterion("VendorOrder in", values, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderNotIn(List<String> values) {
            addCriterion("VendorOrder not in", values, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderBetween(String value1, String value2) {
            addCriterion("VendorOrder between", value1, value2, "vendororder");
            return (Criteria) this;
        }

        public Criteria andVendororderNotBetween(String value1, String value2) {
            addCriterion("VendorOrder not between", value1, value2, "vendororder");
            return (Criteria) this;
        }

        public Criteria andPomodeIsNull() {
            addCriterion("POMode is null");
            return (Criteria) this;
        }

        public Criteria andPomodeIsNotNull() {
            addCriterion("POMode is not null");
            return (Criteria) this;
        }

        public Criteria andPomodeEqualTo(String value) {
            addCriterion("POMode =", value, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeNotEqualTo(String value) {
            addCriterion("POMode <>", value, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeGreaterThan(String value) {
            addCriterion("POMode >", value, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeGreaterThanOrEqualTo(String value) {
            addCriterion("POMode >=", value, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeLessThan(String value) {
            addCriterion("POMode <", value, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeLessThanOrEqualTo(String value) {
            addCriterion("POMode <=", value, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeLike(String value) {
            addCriterion("POMode like", value, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeNotLike(String value) {
            addCriterion("POMode not like", value, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeIn(List<String> values) {
            addCriterion("POMode in", values, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeNotIn(List<String> values) {
            addCriterion("POMode not in", values, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeBetween(String value1, String value2) {
            addCriterion("POMode between", value1, value2, "pomode");
            return (Criteria) this;
        }

        public Criteria andPomodeNotBetween(String value1, String value2) {
            addCriterion("POMode not between", value1, value2, "pomode");
            return (Criteria) this;
        }

        public Criteria andZoneIsNull() {
            addCriterion("Zone is null");
            return (Criteria) this;
        }

        public Criteria andZoneIsNotNull() {
            addCriterion("Zone is not null");
            return (Criteria) this;
        }

        public Criteria andZoneEqualTo(String value) {
            addCriterion("Zone =", value, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneNotEqualTo(String value) {
            addCriterion("Zone <>", value, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneGreaterThan(String value) {
            addCriterion("Zone >", value, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneGreaterThanOrEqualTo(String value) {
            addCriterion("Zone >=", value, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneLessThan(String value) {
            addCriterion("Zone <", value, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneLessThanOrEqualTo(String value) {
            addCriterion("Zone <=", value, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneLike(String value) {
            addCriterion("Zone like", value, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneNotLike(String value) {
            addCriterion("Zone not like", value, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneIn(List<String> values) {
            addCriterion("Zone in", values, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneNotIn(List<String> values) {
            addCriterion("Zone not in", values, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneBetween(String value1, String value2) {
            addCriterion("Zone between", value1, value2, "zone");
            return (Criteria) this;
        }

        public Criteria andZoneNotBetween(String value1, String value2) {
            addCriterion("Zone not between", value1, value2, "zone");
            return (Criteria) this;
        }

        public Criteria andAccstatusIsNull() {
            addCriterion("AccStatus is null");
            return (Criteria) this;
        }

        public Criteria andAccstatusIsNotNull() {
            addCriterion("AccStatus is not null");
            return (Criteria) this;
        }

        public Criteria andAccstatusEqualTo(String value) {
            addCriterion("AccStatus =", value, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusNotEqualTo(String value) {
            addCriterion("AccStatus <>", value, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusGreaterThan(String value) {
            addCriterion("AccStatus >", value, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusGreaterThanOrEqualTo(String value) {
            addCriterion("AccStatus >=", value, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusLessThan(String value) {
            addCriterion("AccStatus <", value, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusLessThanOrEqualTo(String value) {
            addCriterion("AccStatus <=", value, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusLike(String value) {
            addCriterion("AccStatus like", value, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusNotLike(String value) {
            addCriterion("AccStatus not like", value, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusIn(List<String> values) {
            addCriterion("AccStatus in", values, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusNotIn(List<String> values) {
            addCriterion("AccStatus not in", values, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusBetween(String value1, String value2) {
            addCriterion("AccStatus between", value1, value2, "accstatus");
            return (Criteria) this;
        }

        public Criteria andAccstatusNotBetween(String value1, String value2) {
            addCriterion("AccStatus not between", value1, value2, "accstatus");
            return (Criteria) this;
        }

        public Criteria andDistrateIsNull() {
            addCriterion("DistRate is null");
            return (Criteria) this;
        }

        public Criteria andDistrateIsNotNull() {
            addCriterion("DistRate is not null");
            return (Criteria) this;
        }

        public Criteria andDistrateEqualTo(BigDecimal value) {
            addCriterion("DistRate =", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateNotEqualTo(BigDecimal value) {
            addCriterion("DistRate <>", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateGreaterThan(BigDecimal value) {
            addCriterion("DistRate >", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DistRate >=", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateLessThan(BigDecimal value) {
            addCriterion("DistRate <", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DistRate <=", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateIn(List<BigDecimal> values) {
            addCriterion("DistRate in", values, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateNotIn(List<BigDecimal> values) {
            addCriterion("DistRate not in", values, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DistRate between", value1, value2, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DistRate not between", value1, value2, "distrate");
            return (Criteria) this;
        }

        public Criteria andMarttypeIsNull() {
            addCriterion("MartType is null");
            return (Criteria) this;
        }

        public Criteria andMarttypeIsNotNull() {
            addCriterion("MartType is not null");
            return (Criteria) this;
        }

        public Criteria andMarttypeEqualTo(String value) {
            addCriterion("MartType =", value, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeNotEqualTo(String value) {
            addCriterion("MartType <>", value, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeGreaterThan(String value) {
            addCriterion("MartType >", value, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeGreaterThanOrEqualTo(String value) {
            addCriterion("MartType >=", value, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeLessThan(String value) {
            addCriterion("MartType <", value, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeLessThanOrEqualTo(String value) {
            addCriterion("MartType <=", value, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeLike(String value) {
            addCriterion("MartType like", value, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeNotLike(String value) {
            addCriterion("MartType not like", value, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeIn(List<String> values) {
            addCriterion("MartType in", values, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeNotIn(List<String> values) {
            addCriterion("MartType not in", values, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeBetween(String value1, String value2) {
            addCriterion("MartType between", value1, value2, "marttype");
            return (Criteria) this;
        }

        public Criteria andMarttypeNotBetween(String value1, String value2) {
            addCriterion("MartType not between", value1, value2, "marttype");
            return (Criteria) this;
        }

        public Criteria andStdateIsNull() {
            addCriterion("STDate is null");
            return (Criteria) this;
        }

        public Criteria andStdateIsNotNull() {
            addCriterion("STDate is not null");
            return (Criteria) this;
        }

        public Criteria andStdateEqualTo(Date value) {
            addCriterion("STDate =", value, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateNotEqualTo(Date value) {
            addCriterion("STDate <>", value, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateGreaterThan(Date value) {
            addCriterion("STDate >", value, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateGreaterThanOrEqualTo(Date value) {
            addCriterion("STDate >=", value, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateLessThan(Date value) {
            addCriterion("STDate <", value, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateLessThanOrEqualTo(Date value) {
            addCriterion("STDate <=", value, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateIn(List<Date> values) {
            addCriterion("STDate in", values, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateNotIn(List<Date> values) {
            addCriterion("STDate not in", values, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateBetween(Date value1, Date value2) {
            addCriterion("STDate between", value1, value2, "stdate");
            return (Criteria) this;
        }

        public Criteria andStdateNotBetween(Date value1, Date value2) {
            addCriterion("STDate not between", value1, value2, "stdate");
            return (Criteria) this;
        }

        public Criteria andTackrateIsNull() {
            addCriterion("TackRate is null");
            return (Criteria) this;
        }

        public Criteria andTackrateIsNotNull() {
            addCriterion("TackRate is not null");
            return (Criteria) this;
        }

        public Criteria andTackrateEqualTo(BigDecimal value) {
            addCriterion("TackRate =", value, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateNotEqualTo(BigDecimal value) {
            addCriterion("TackRate <>", value, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateGreaterThan(BigDecimal value) {
            addCriterion("TackRate >", value, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TackRate >=", value, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateLessThan(BigDecimal value) {
            addCriterion("TackRate <", value, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TackRate <=", value, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateIn(List<BigDecimal> values) {
            addCriterion("TackRate in", values, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateNotIn(List<BigDecimal> values) {
            addCriterion("TackRate not in", values, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TackRate between", value1, value2, "tackrate");
            return (Criteria) this;
        }

        public Criteria andTackrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TackRate not between", value1, value2, "tackrate");
            return (Criteria) this;
        }

        public Criteria andStoretypeIsNull() {
            addCriterion("StoreType is null");
            return (Criteria) this;
        }

        public Criteria andStoretypeIsNotNull() {
            addCriterion("StoreType is not null");
            return (Criteria) this;
        }

        public Criteria andStoretypeEqualTo(String value) {
            addCriterion("StoreType =", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeNotEqualTo(String value) {
            addCriterion("StoreType <>", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeGreaterThan(String value) {
            addCriterion("StoreType >", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreType >=", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeLessThan(String value) {
            addCriterion("StoreType <", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeLessThanOrEqualTo(String value) {
            addCriterion("StoreType <=", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeLike(String value) {
            addCriterion("StoreType like", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeNotLike(String value) {
            addCriterion("StoreType not like", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeIn(List<String> values) {
            addCriterion("StoreType in", values, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeNotIn(List<String> values) {
            addCriterion("StoreType not in", values, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeBetween(String value1, String value2) {
            addCriterion("StoreType between", value1, value2, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeNotBetween(String value1, String value2) {
            addCriterion("StoreType not between", value1, value2, "storetype");
            return (Criteria) this;
        }

        public Criteria andItemsetupIsNull() {
            addCriterion("ItemSetup is null");
            return (Criteria) this;
        }

        public Criteria andItemsetupIsNotNull() {
            addCriterion("ItemSetup is not null");
            return (Criteria) this;
        }

        public Criteria andItemsetupEqualTo(String value) {
            addCriterion("ItemSetup =", value, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupNotEqualTo(String value) {
            addCriterion("ItemSetup <>", value, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupGreaterThan(String value) {
            addCriterion("ItemSetup >", value, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupGreaterThanOrEqualTo(String value) {
            addCriterion("ItemSetup >=", value, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupLessThan(String value) {
            addCriterion("ItemSetup <", value, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupLessThanOrEqualTo(String value) {
            addCriterion("ItemSetup <=", value, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupLike(String value) {
            addCriterion("ItemSetup like", value, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupNotLike(String value) {
            addCriterion("ItemSetup not like", value, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupIn(List<String> values) {
            addCriterion("ItemSetup in", values, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupNotIn(List<String> values) {
            addCriterion("ItemSetup not in", values, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupBetween(String value1, String value2) {
            addCriterion("ItemSetup between", value1, value2, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andItemsetupNotBetween(String value1, String value2) {
            addCriterion("ItemSetup not between", value1, value2, "itemsetup");
            return (Criteria) this;
        }

        public Criteria andShallbaladateIsNull() {
            addCriterion("ShallBalaDate is null");
            return (Criteria) this;
        }

        public Criteria andShallbaladateIsNotNull() {
            addCriterion("ShallBalaDate is not null");
            return (Criteria) this;
        }

        public Criteria andShallbaladateEqualTo(Date value) {
            addCriterion("ShallBalaDate =", value, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateNotEqualTo(Date value) {
            addCriterion("ShallBalaDate <>", value, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateGreaterThan(Date value) {
            addCriterion("ShallBalaDate >", value, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateGreaterThanOrEqualTo(Date value) {
            addCriterion("ShallBalaDate >=", value, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateLessThan(Date value) {
            addCriterion("ShallBalaDate <", value, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateLessThanOrEqualTo(Date value) {
            addCriterion("ShallBalaDate <=", value, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateIn(List<Date> values) {
            addCriterion("ShallBalaDate in", values, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateNotIn(List<Date> values) {
            addCriterion("ShallBalaDate not in", values, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateBetween(Date value1, Date value2) {
            addCriterion("ShallBalaDate between", value1, value2, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andShallbaladateNotBetween(Date value1, Date value2) {
            addCriterion("ShallBalaDate not between", value1, value2, "shallbaladate");
            return (Criteria) this;
        }

        public Criteria andStockceilingIsNull() {
            addCriterion("StockCeiling is null");
            return (Criteria) this;
        }

        public Criteria andStockceilingIsNotNull() {
            addCriterion("StockCeiling is not null");
            return (Criteria) this;
        }

        public Criteria andStockceilingEqualTo(BigDecimal value) {
            addCriterion("StockCeiling =", value, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingNotEqualTo(BigDecimal value) {
            addCriterion("StockCeiling <>", value, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingGreaterThan(BigDecimal value) {
            addCriterion("StockCeiling >", value, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("StockCeiling >=", value, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingLessThan(BigDecimal value) {
            addCriterion("StockCeiling <", value, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("StockCeiling <=", value, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingIn(List<BigDecimal> values) {
            addCriterion("StockCeiling in", values, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingNotIn(List<BigDecimal> values) {
            addCriterion("StockCeiling not in", values, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("StockCeiling between", value1, value2, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andStockceilingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("StockCeiling not between", value1, value2, "stockceiling");
            return (Criteria) this;
        }

        public Criteria andRasuserIsNull() {
            addCriterion("RasUser is null");
            return (Criteria) this;
        }

        public Criteria andRasuserIsNotNull() {
            addCriterion("RasUser is not null");
            return (Criteria) this;
        }

        public Criteria andRasuserEqualTo(String value) {
            addCriterion("RasUser =", value, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserNotEqualTo(String value) {
            addCriterion("RasUser <>", value, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserGreaterThan(String value) {
            addCriterion("RasUser >", value, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserGreaterThanOrEqualTo(String value) {
            addCriterion("RasUser >=", value, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserLessThan(String value) {
            addCriterion("RasUser <", value, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserLessThanOrEqualTo(String value) {
            addCriterion("RasUser <=", value, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserLike(String value) {
            addCriterion("RasUser like", value, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserNotLike(String value) {
            addCriterion("RasUser not like", value, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserIn(List<String> values) {
            addCriterion("RasUser in", values, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserNotIn(List<String> values) {
            addCriterion("RasUser not in", values, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserBetween(String value1, String value2) {
            addCriterion("RasUser between", value1, value2, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRasuserNotBetween(String value1, String value2) {
            addCriterion("RasUser not between", value1, value2, "rasuser");
            return (Criteria) this;
        }

        public Criteria andRaspwdIsNull() {
            addCriterion("RasPWD is null");
            return (Criteria) this;
        }

        public Criteria andRaspwdIsNotNull() {
            addCriterion("RasPWD is not null");
            return (Criteria) this;
        }

        public Criteria andRaspwdEqualTo(String value) {
            addCriterion("RasPWD =", value, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdNotEqualTo(String value) {
            addCriterion("RasPWD <>", value, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdGreaterThan(String value) {
            addCriterion("RasPWD >", value, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdGreaterThanOrEqualTo(String value) {
            addCriterion("RasPWD >=", value, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdLessThan(String value) {
            addCriterion("RasPWD <", value, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdLessThanOrEqualTo(String value) {
            addCriterion("RasPWD <=", value, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdLike(String value) {
            addCriterion("RasPWD like", value, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdNotLike(String value) {
            addCriterion("RasPWD not like", value, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdIn(List<String> values) {
            addCriterion("RasPWD in", values, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdNotIn(List<String> values) {
            addCriterion("RasPWD not in", values, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdBetween(String value1, String value2) {
            addCriterion("RasPWD between", value1, value2, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRaspwdNotBetween(String value1, String value2) {
            addCriterion("RasPWD not between", value1, value2, "raspwd");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnIsNull() {
            addCriterion("RasDefaultPN is null");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnIsNotNull() {
            addCriterion("RasDefaultPN is not null");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnEqualTo(String value) {
            addCriterion("RasDefaultPN =", value, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnNotEqualTo(String value) {
            addCriterion("RasDefaultPN <>", value, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnGreaterThan(String value) {
            addCriterion("RasDefaultPN >", value, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnGreaterThanOrEqualTo(String value) {
            addCriterion("RasDefaultPN >=", value, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnLessThan(String value) {
            addCriterion("RasDefaultPN <", value, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnLessThanOrEqualTo(String value) {
            addCriterion("RasDefaultPN <=", value, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnLike(String value) {
            addCriterion("RasDefaultPN like", value, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnNotLike(String value) {
            addCriterion("RasDefaultPN not like", value, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnIn(List<String> values) {
            addCriterion("RasDefaultPN in", values, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnNotIn(List<String> values) {
            addCriterion("RasDefaultPN not in", values, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnBetween(String value1, String value2) {
            addCriterion("RasDefaultPN between", value1, value2, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andRasdefaultpnNotBetween(String value1, String value2) {
            addCriterion("RasDefaultPN not between", value1, value2, "rasdefaultpn");
            return (Criteria) this;
        }

        public Criteria andTranserverIsNull() {
            addCriterion("TranServer is null");
            return (Criteria) this;
        }

        public Criteria andTranserverIsNotNull() {
            addCriterion("TranServer is not null");
            return (Criteria) this;
        }

        public Criteria andTranserverEqualTo(String value) {
            addCriterion("TranServer =", value, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverNotEqualTo(String value) {
            addCriterion("TranServer <>", value, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverGreaterThan(String value) {
            addCriterion("TranServer >", value, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverGreaterThanOrEqualTo(String value) {
            addCriterion("TranServer >=", value, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverLessThan(String value) {
            addCriterion("TranServer <", value, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverLessThanOrEqualTo(String value) {
            addCriterion("TranServer <=", value, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverLike(String value) {
            addCriterion("TranServer like", value, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverNotLike(String value) {
            addCriterion("TranServer not like", value, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverIn(List<String> values) {
            addCriterion("TranServer in", values, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverNotIn(List<String> values) {
            addCriterion("TranServer not in", values, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverBetween(String value1, String value2) {
            addCriterion("TranServer between", value1, value2, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranserverNotBetween(String value1, String value2) {
            addCriterion("TranServer not between", value1, value2, "transerver");
            return (Criteria) this;
        }

        public Criteria andTranuserIsNull() {
            addCriterion("TranUser is null");
            return (Criteria) this;
        }

        public Criteria andTranuserIsNotNull() {
            addCriterion("TranUser is not null");
            return (Criteria) this;
        }

        public Criteria andTranuserEqualTo(String value) {
            addCriterion("TranUser =", value, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserNotEqualTo(String value) {
            addCriterion("TranUser <>", value, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserGreaterThan(String value) {
            addCriterion("TranUser >", value, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserGreaterThanOrEqualTo(String value) {
            addCriterion("TranUser >=", value, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserLessThan(String value) {
            addCriterion("TranUser <", value, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserLessThanOrEqualTo(String value) {
            addCriterion("TranUser <=", value, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserLike(String value) {
            addCriterion("TranUser like", value, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserNotLike(String value) {
            addCriterion("TranUser not like", value, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserIn(List<String> values) {
            addCriterion("TranUser in", values, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserNotIn(List<String> values) {
            addCriterion("TranUser not in", values, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserBetween(String value1, String value2) {
            addCriterion("TranUser between", value1, value2, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranuserNotBetween(String value1, String value2) {
            addCriterion("TranUser not between", value1, value2, "tranuser");
            return (Criteria) this;
        }

        public Criteria andTranpwdIsNull() {
            addCriterion("TranPWD is null");
            return (Criteria) this;
        }

        public Criteria andTranpwdIsNotNull() {
            addCriterion("TranPWD is not null");
            return (Criteria) this;
        }

        public Criteria andTranpwdEqualTo(String value) {
            addCriterion("TranPWD =", value, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdNotEqualTo(String value) {
            addCriterion("TranPWD <>", value, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdGreaterThan(String value) {
            addCriterion("TranPWD >", value, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdGreaterThanOrEqualTo(String value) {
            addCriterion("TranPWD >=", value, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdLessThan(String value) {
            addCriterion("TranPWD <", value, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdLessThanOrEqualTo(String value) {
            addCriterion("TranPWD <=", value, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdLike(String value) {
            addCriterion("TranPWD like", value, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdNotLike(String value) {
            addCriterion("TranPWD not like", value, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdIn(List<String> values) {
            addCriterion("TranPWD in", values, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdNotIn(List<String> values) {
            addCriterion("TranPWD not in", values, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdBetween(String value1, String value2) {
            addCriterion("TranPWD between", value1, value2, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andTranpwdNotBetween(String value1, String value2) {
            addCriterion("TranPWD not between", value1, value2, "tranpwd");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirIsNull() {
            addCriterion("FtpMainDir is null");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirIsNotNull() {
            addCriterion("FtpMainDir is not null");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirEqualTo(String value) {
            addCriterion("FtpMainDir =", value, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirNotEqualTo(String value) {
            addCriterion("FtpMainDir <>", value, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirGreaterThan(String value) {
            addCriterion("FtpMainDir >", value, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirGreaterThanOrEqualTo(String value) {
            addCriterion("FtpMainDir >=", value, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirLessThan(String value) {
            addCriterion("FtpMainDir <", value, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirLessThanOrEqualTo(String value) {
            addCriterion("FtpMainDir <=", value, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirLike(String value) {
            addCriterion("FtpMainDir like", value, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirNotLike(String value) {
            addCriterion("FtpMainDir not like", value, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirIn(List<String> values) {
            addCriterion("FtpMainDir in", values, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirNotIn(List<String> values) {
            addCriterion("FtpMainDir not in", values, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirBetween(String value1, String value2) {
            addCriterion("FtpMainDir between", value1, value2, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtpmaindirNotBetween(String value1, String value2) {
            addCriterion("FtpMainDir not between", value1, value2, "ftpmaindir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirIsNull() {
            addCriterion("FtpHisDir is null");
            return (Criteria) this;
        }

        public Criteria andFtphisdirIsNotNull() {
            addCriterion("FtpHisDir is not null");
            return (Criteria) this;
        }

        public Criteria andFtphisdirEqualTo(String value) {
            addCriterion("FtpHisDir =", value, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirNotEqualTo(String value) {
            addCriterion("FtpHisDir <>", value, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirGreaterThan(String value) {
            addCriterion("FtpHisDir >", value, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirGreaterThanOrEqualTo(String value) {
            addCriterion("FtpHisDir >=", value, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirLessThan(String value) {
            addCriterion("FtpHisDir <", value, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirLessThanOrEqualTo(String value) {
            addCriterion("FtpHisDir <=", value, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirLike(String value) {
            addCriterion("FtpHisDir like", value, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirNotLike(String value) {
            addCriterion("FtpHisDir not like", value, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirIn(List<String> values) {
            addCriterion("FtpHisDir in", values, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirNotIn(List<String> values) {
            addCriterion("FtpHisDir not in", values, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirBetween(String value1, String value2) {
            addCriterion("FtpHisDir between", value1, value2, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andFtphisdirNotBetween(String value1, String value2) {
            addCriterion("FtpHisDir not between", value1, value2, "ftphisdir");
            return (Criteria) this;
        }

        public Criteria andTackdatadateIsNull() {
            addCriterion("TackDataDate is null");
            return (Criteria) this;
        }

        public Criteria andTackdatadateIsNotNull() {
            addCriterion("TackDataDate is not null");
            return (Criteria) this;
        }

        public Criteria andTackdatadateEqualTo(Date value) {
            addCriterion("TackDataDate =", value, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateNotEqualTo(Date value) {
            addCriterion("TackDataDate <>", value, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateGreaterThan(Date value) {
            addCriterion("TackDataDate >", value, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateGreaterThanOrEqualTo(Date value) {
            addCriterion("TackDataDate >=", value, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateLessThan(Date value) {
            addCriterion("TackDataDate <", value, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateLessThanOrEqualTo(Date value) {
            addCriterion("TackDataDate <=", value, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateIn(List<Date> values) {
            addCriterion("TackDataDate in", values, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateNotIn(List<Date> values) {
            addCriterion("TackDataDate not in", values, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateBetween(Date value1, Date value2) {
            addCriterion("TackDataDate between", value1, value2, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andTackdatadateNotBetween(Date value1, Date value2) {
            addCriterion("TackDataDate not between", value1, value2, "tackdatadate");
            return (Criteria) this;
        }

        public Criteria andRevfield1IsNull() {
            addCriterion("RevField1 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield1IsNotNull() {
            addCriterion("RevField1 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield1EqualTo(Date value) {
            addCriterion("RevField1 =", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1NotEqualTo(Date value) {
            addCriterion("RevField1 <>", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1GreaterThan(Date value) {
            addCriterion("RevField1 >", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1GreaterThanOrEqualTo(Date value) {
            addCriterion("RevField1 >=", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1LessThan(Date value) {
            addCriterion("RevField1 <", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1LessThanOrEqualTo(Date value) {
            addCriterion("RevField1 <=", value, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1In(List<Date> values) {
            addCriterion("RevField1 in", values, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1NotIn(List<Date> values) {
            addCriterion("RevField1 not in", values, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1Between(Date value1, Date value2) {
            addCriterion("RevField1 between", value1, value2, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield1NotBetween(Date value1, Date value2) {
            addCriterion("RevField1 not between", value1, value2, "revfield1");
            return (Criteria) this;
        }

        public Criteria andRevfield2IsNull() {
            addCriterion("RevField2 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield2IsNotNull() {
            addCriterion("RevField2 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield2EqualTo(Date value) {
            addCriterion("RevField2 =", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2NotEqualTo(Date value) {
            addCriterion("RevField2 <>", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2GreaterThan(Date value) {
            addCriterion("RevField2 >", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2GreaterThanOrEqualTo(Date value) {
            addCriterion("RevField2 >=", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2LessThan(Date value) {
            addCriterion("RevField2 <", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2LessThanOrEqualTo(Date value) {
            addCriterion("RevField2 <=", value, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2In(List<Date> values) {
            addCriterion("RevField2 in", values, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2NotIn(List<Date> values) {
            addCriterion("RevField2 not in", values, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2Between(Date value1, Date value2) {
            addCriterion("RevField2 between", value1, value2, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield2NotBetween(Date value1, Date value2) {
            addCriterion("RevField2 not between", value1, value2, "revfield2");
            return (Criteria) this;
        }

        public Criteria andRevfield3IsNull() {
            addCriterion("RevField3 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield3IsNotNull() {
            addCriterion("RevField3 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield3EqualTo(String value) {
            addCriterion("RevField3 =", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3NotEqualTo(String value) {
            addCriterion("RevField3 <>", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3GreaterThan(String value) {
            addCriterion("RevField3 >", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3GreaterThanOrEqualTo(String value) {
            addCriterion("RevField3 >=", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3LessThan(String value) {
            addCriterion("RevField3 <", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3LessThanOrEqualTo(String value) {
            addCriterion("RevField3 <=", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3Like(String value) {
            addCriterion("RevField3 like", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3NotLike(String value) {
            addCriterion("RevField3 not like", value, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3In(List<String> values) {
            addCriterion("RevField3 in", values, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3NotIn(List<String> values) {
            addCriterion("RevField3 not in", values, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3Between(String value1, String value2) {
            addCriterion("RevField3 between", value1, value2, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield3NotBetween(String value1, String value2) {
            addCriterion("RevField3 not between", value1, value2, "revfield3");
            return (Criteria) this;
        }

        public Criteria andRevfield4IsNull() {
            addCriterion("RevField4 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield4IsNotNull() {
            addCriterion("RevField4 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield4EqualTo(String value) {
            addCriterion("RevField4 =", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4NotEqualTo(String value) {
            addCriterion("RevField4 <>", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4GreaterThan(String value) {
            addCriterion("RevField4 >", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4GreaterThanOrEqualTo(String value) {
            addCriterion("RevField4 >=", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4LessThan(String value) {
            addCriterion("RevField4 <", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4LessThanOrEqualTo(String value) {
            addCriterion("RevField4 <=", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4Like(String value) {
            addCriterion("RevField4 like", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4NotLike(String value) {
            addCriterion("RevField4 not like", value, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4In(List<String> values) {
            addCriterion("RevField4 in", values, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4NotIn(List<String> values) {
            addCriterion("RevField4 not in", values, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4Between(String value1, String value2) {
            addCriterion("RevField4 between", value1, value2, "revfield4");
            return (Criteria) this;
        }

        public Criteria andRevfield4NotBetween(String value1, String value2) {
            addCriterion("RevField4 not between", value1, value2, "revfield4");
            return (Criteria) this;
        }

        public Criteria andCheckdeptIsNull() {
            addCriterion("CheckDept is null");
            return (Criteria) this;
        }

        public Criteria andCheckdeptIsNotNull() {
            addCriterion("CheckDept is not null");
            return (Criteria) this;
        }

        public Criteria andCheckdeptEqualTo(String value) {
            addCriterion("CheckDept =", value, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptNotEqualTo(String value) {
            addCriterion("CheckDept <>", value, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptGreaterThan(String value) {
            addCriterion("CheckDept >", value, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptGreaterThanOrEqualTo(String value) {
            addCriterion("CheckDept >=", value, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptLessThan(String value) {
            addCriterion("CheckDept <", value, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptLessThanOrEqualTo(String value) {
            addCriterion("CheckDept <=", value, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptLike(String value) {
            addCriterion("CheckDept like", value, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptNotLike(String value) {
            addCriterion("CheckDept not like", value, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptIn(List<String> values) {
            addCriterion("CheckDept in", values, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptNotIn(List<String> values) {
            addCriterion("CheckDept not in", values, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptBetween(String value1, String value2) {
            addCriterion("CheckDept between", value1, value2, "checkdept");
            return (Criteria) this;
        }

        public Criteria andCheckdeptNotBetween(String value1, String value2) {
            addCriterion("CheckDept not between", value1, value2, "checkdept");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNull() {
            addCriterion("DCCode is null");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNotNull() {
            addCriterion("DCCode is not null");
            return (Criteria) this;
        }

        public Criteria andDccodeEqualTo(String value) {
            addCriterion("DCCode =", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotEqualTo(String value) {
            addCriterion("DCCode <>", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThan(String value) {
            addCriterion("DCCode >", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThanOrEqualTo(String value) {
            addCriterion("DCCode >=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThan(String value) {
            addCriterion("DCCode <", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThanOrEqualTo(String value) {
            addCriterion("DCCode <=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLike(String value) {
            addCriterion("DCCode like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotLike(String value) {
            addCriterion("DCCode not like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeIn(List<String> values) {
            addCriterion("DCCode in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotIn(List<String> values) {
            addCriterion("DCCode not in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeBetween(String value1, String value2) {
            addCriterion("DCCode between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotBetween(String value1, String value2) {
            addCriterion("DCCode not between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andRevfield5IsNull() {
            addCriterion("RevField5 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield5IsNotNull() {
            addCriterion("RevField5 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield5EqualTo(String value) {
            addCriterion("RevField5 =", value, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5NotEqualTo(String value) {
            addCriterion("RevField5 <>", value, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5GreaterThan(String value) {
            addCriterion("RevField5 >", value, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5GreaterThanOrEqualTo(String value) {
            addCriterion("RevField5 >=", value, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5LessThan(String value) {
            addCriterion("RevField5 <", value, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5LessThanOrEqualTo(String value) {
            addCriterion("RevField5 <=", value, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5Like(String value) {
            addCriterion("RevField5 like", value, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5NotLike(String value) {
            addCriterion("RevField5 not like", value, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5In(List<String> values) {
            addCriterion("RevField5 in", values, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5NotIn(List<String> values) {
            addCriterion("RevField5 not in", values, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5Between(String value1, String value2) {
            addCriterion("RevField5 between", value1, value2, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield5NotBetween(String value1, String value2) {
            addCriterion("RevField5 not between", value1, value2, "revfield5");
            return (Criteria) this;
        }

        public Criteria andRevfield6IsNull() {
            addCriterion("RevField6 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield6IsNotNull() {
            addCriterion("RevField6 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield6EqualTo(String value) {
            addCriterion("RevField6 =", value, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6NotEqualTo(String value) {
            addCriterion("RevField6 <>", value, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6GreaterThan(String value) {
            addCriterion("RevField6 >", value, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6GreaterThanOrEqualTo(String value) {
            addCriterion("RevField6 >=", value, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6LessThan(String value) {
            addCriterion("RevField6 <", value, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6LessThanOrEqualTo(String value) {
            addCriterion("RevField6 <=", value, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6Like(String value) {
            addCriterion("RevField6 like", value, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6NotLike(String value) {
            addCriterion("RevField6 not like", value, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6In(List<String> values) {
            addCriterion("RevField6 in", values, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6NotIn(List<String> values) {
            addCriterion("RevField6 not in", values, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6Between(String value1, String value2) {
            addCriterion("RevField6 between", value1, value2, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield6NotBetween(String value1, String value2) {
            addCriterion("RevField6 not between", value1, value2, "revfield6");
            return (Criteria) this;
        }

        public Criteria andRevfield7IsNull() {
            addCriterion("RevField7 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield7IsNotNull() {
            addCriterion("RevField7 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield7EqualTo(String value) {
            addCriterion("RevField7 =", value, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7NotEqualTo(String value) {
            addCriterion("RevField7 <>", value, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7GreaterThan(String value) {
            addCriterion("RevField7 >", value, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7GreaterThanOrEqualTo(String value) {
            addCriterion("RevField7 >=", value, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7LessThan(String value) {
            addCriterion("RevField7 <", value, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7LessThanOrEqualTo(String value) {
            addCriterion("RevField7 <=", value, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7Like(String value) {
            addCriterion("RevField7 like", value, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7NotLike(String value) {
            addCriterion("RevField7 not like", value, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7In(List<String> values) {
            addCriterion("RevField7 in", values, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7NotIn(List<String> values) {
            addCriterion("RevField7 not in", values, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7Between(String value1, String value2) {
            addCriterion("RevField7 between", value1, value2, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield7NotBetween(String value1, String value2) {
            addCriterion("RevField7 not between", value1, value2, "revfield7");
            return (Criteria) this;
        }

        public Criteria andRevfield8IsNull() {
            addCriterion("RevField8 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield8IsNotNull() {
            addCriterion("RevField8 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield8EqualTo(Date value) {
            addCriterion("RevField8 =", value, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8NotEqualTo(Date value) {
            addCriterion("RevField8 <>", value, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8GreaterThan(Date value) {
            addCriterion("RevField8 >", value, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8GreaterThanOrEqualTo(Date value) {
            addCriterion("RevField8 >=", value, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8LessThan(Date value) {
            addCriterion("RevField8 <", value, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8LessThanOrEqualTo(Date value) {
            addCriterion("RevField8 <=", value, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8In(List<Date> values) {
            addCriterion("RevField8 in", values, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8NotIn(List<Date> values) {
            addCriterion("RevField8 not in", values, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8Between(Date value1, Date value2) {
            addCriterion("RevField8 between", value1, value2, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield8NotBetween(Date value1, Date value2) {
            addCriterion("RevField8 not between", value1, value2, "revfield8");
            return (Criteria) this;
        }

        public Criteria andRevfield9IsNull() {
            addCriterion("RevField9 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield9IsNotNull() {
            addCriterion("RevField9 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield9EqualTo(Date value) {
            addCriterion("RevField9 =", value, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9NotEqualTo(Date value) {
            addCriterion("RevField9 <>", value, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9GreaterThan(Date value) {
            addCriterion("RevField9 >", value, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9GreaterThanOrEqualTo(Date value) {
            addCriterion("RevField9 >=", value, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9LessThan(Date value) {
            addCriterion("RevField9 <", value, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9LessThanOrEqualTo(Date value) {
            addCriterion("RevField9 <=", value, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9In(List<Date> values) {
            addCriterion("RevField9 in", values, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9NotIn(List<Date> values) {
            addCriterion("RevField9 not in", values, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9Between(Date value1, Date value2) {
            addCriterion("RevField9 between", value1, value2, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield9NotBetween(Date value1, Date value2) {
            addCriterion("RevField9 not between", value1, value2, "revfield9");
            return (Criteria) this;
        }

        public Criteria andRevfield10IsNull() {
            addCriterion("RevField10 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield10IsNotNull() {
            addCriterion("RevField10 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield10EqualTo(Date value) {
            addCriterion("RevField10 =", value, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10NotEqualTo(Date value) {
            addCriterion("RevField10 <>", value, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10GreaterThan(Date value) {
            addCriterion("RevField10 >", value, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10GreaterThanOrEqualTo(Date value) {
            addCriterion("RevField10 >=", value, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10LessThan(Date value) {
            addCriterion("RevField10 <", value, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10LessThanOrEqualTo(Date value) {
            addCriterion("RevField10 <=", value, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10In(List<Date> values) {
            addCriterion("RevField10 in", values, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10NotIn(List<Date> values) {
            addCriterion("RevField10 not in", values, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10Between(Date value1, Date value2) {
            addCriterion("RevField10 between", value1, value2, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield10NotBetween(Date value1, Date value2) {
            addCriterion("RevField10 not between", value1, value2, "revfield10");
            return (Criteria) this;
        }

        public Criteria andRevfield11IsNull() {
            addCriterion("RevField11 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield11IsNotNull() {
            addCriterion("RevField11 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield11EqualTo(BigDecimal value) {
            addCriterion("RevField11 =", value, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11NotEqualTo(BigDecimal value) {
            addCriterion("RevField11 <>", value, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11GreaterThan(BigDecimal value) {
            addCriterion("RevField11 >", value, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RevField11 >=", value, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11LessThan(BigDecimal value) {
            addCriterion("RevField11 <", value, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11LessThanOrEqualTo(BigDecimal value) {
            addCriterion("RevField11 <=", value, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11In(List<BigDecimal> values) {
            addCriterion("RevField11 in", values, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11NotIn(List<BigDecimal> values) {
            addCriterion("RevField11 not in", values, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("RevField11 between", value1, value2, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield11NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RevField11 not between", value1, value2, "revfield11");
            return (Criteria) this;
        }

        public Criteria andRevfield12IsNull() {
            addCriterion("RevField12 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield12IsNotNull() {
            addCriterion("RevField12 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield12EqualTo(BigDecimal value) {
            addCriterion("RevField12 =", value, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12NotEqualTo(BigDecimal value) {
            addCriterion("RevField12 <>", value, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12GreaterThan(BigDecimal value) {
            addCriterion("RevField12 >", value, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RevField12 >=", value, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12LessThan(BigDecimal value) {
            addCriterion("RevField12 <", value, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12LessThanOrEqualTo(BigDecimal value) {
            addCriterion("RevField12 <=", value, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12In(List<BigDecimal> values) {
            addCriterion("RevField12 in", values, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12NotIn(List<BigDecimal> values) {
            addCriterion("RevField12 not in", values, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("RevField12 between", value1, value2, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield12NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RevField12 not between", value1, value2, "revfield12");
            return (Criteria) this;
        }

        public Criteria andRevfield13IsNull() {
            addCriterion("RevField13 is null");
            return (Criteria) this;
        }

        public Criteria andRevfield13IsNotNull() {
            addCriterion("RevField13 is not null");
            return (Criteria) this;
        }

        public Criteria andRevfield13EqualTo(BigDecimal value) {
            addCriterion("RevField13 =", value, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13NotEqualTo(BigDecimal value) {
            addCriterion("RevField13 <>", value, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13GreaterThan(BigDecimal value) {
            addCriterion("RevField13 >", value, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RevField13 >=", value, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13LessThan(BigDecimal value) {
            addCriterion("RevField13 <", value, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13LessThanOrEqualTo(BigDecimal value) {
            addCriterion("RevField13 <=", value, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13In(List<BigDecimal> values) {
            addCriterion("RevField13 in", values, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13NotIn(List<BigDecimal> values) {
            addCriterion("RevField13 not in", values, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("RevField13 between", value1, value2, "revfield13");
            return (Criteria) this;
        }

        public Criteria andRevfield13NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RevField13 not between", value1, value2, "revfield13");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNull() {
            addCriterion("OrderTime is null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNotNull() {
            addCriterion("OrderTime is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeEqualTo(String value) {
            addCriterion("OrderTime =", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotEqualTo(String value) {
            addCriterion("OrderTime <>", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThan(String value) {
            addCriterion("OrderTime >", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThanOrEqualTo(String value) {
            addCriterion("OrderTime >=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThan(String value) {
            addCriterion("OrderTime <", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThanOrEqualTo(String value) {
            addCriterion("OrderTime <=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLike(String value) {
            addCriterion("OrderTime like", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotLike(String value) {
            addCriterion("OrderTime not like", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIn(List<String> values) {
            addCriterion("OrderTime in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotIn(List<String> values) {
            addCriterion("OrderTime not in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeBetween(String value1, String value2) {
            addCriterion("OrderTime between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotBetween(String value1, String value2) {
            addCriterion("OrderTime not between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysIsNull() {
            addCriterion("DeliverDays is null");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysIsNotNull() {
            addCriterion("DeliverDays is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysEqualTo(Integer value) {
            addCriterion("DeliverDays =", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysNotEqualTo(Integer value) {
            addCriterion("DeliverDays <>", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysGreaterThan(Integer value) {
            addCriterion("DeliverDays >", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("DeliverDays >=", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysLessThan(Integer value) {
            addCriterion("DeliverDays <", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysLessThanOrEqualTo(Integer value) {
            addCriterion("DeliverDays <=", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysIn(List<Integer> values) {
            addCriterion("DeliverDays in", values, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysNotIn(List<Integer> values) {
            addCriterion("DeliverDays not in", values, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysBetween(Integer value1, Integer value2) {
            addCriterion("DeliverDays between", value1, value2, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysNotBetween(Integer value1, Integer value2) {
            addCriterion("DeliverDays not between", value1, value2, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andMasterIsNull() {
            addCriterion("Master is null");
            return (Criteria) this;
        }

        public Criteria andMasterIsNotNull() {
            addCriterion("Master is not null");
            return (Criteria) this;
        }

        public Criteria andMasterEqualTo(String value) {
            addCriterion("Master =", value, "master");
            return (Criteria) this;
        }

        public Criteria andMasterNotEqualTo(String value) {
            addCriterion("Master <>", value, "master");
            return (Criteria) this;
        }

        public Criteria andMasterGreaterThan(String value) {
            addCriterion("Master >", value, "master");
            return (Criteria) this;
        }

        public Criteria andMasterGreaterThanOrEqualTo(String value) {
            addCriterion("Master >=", value, "master");
            return (Criteria) this;
        }

        public Criteria andMasterLessThan(String value) {
            addCriterion("Master <", value, "master");
            return (Criteria) this;
        }

        public Criteria andMasterLessThanOrEqualTo(String value) {
            addCriterion("Master <=", value, "master");
            return (Criteria) this;
        }

        public Criteria andMasterLike(String value) {
            addCriterion("Master like", value, "master");
            return (Criteria) this;
        }

        public Criteria andMasterNotLike(String value) {
            addCriterion("Master not like", value, "master");
            return (Criteria) this;
        }

        public Criteria andMasterIn(List<String> values) {
            addCriterion("Master in", values, "master");
            return (Criteria) this;
        }

        public Criteria andMasterNotIn(List<String> values) {
            addCriterion("Master not in", values, "master");
            return (Criteria) this;
        }

        public Criteria andMasterBetween(String value1, String value2) {
            addCriterion("Master between", value1, value2, "master");
            return (Criteria) this;
        }

        public Criteria andMasterNotBetween(String value1, String value2) {
            addCriterion("Master not between", value1, value2, "master");
            return (Criteria) this;
        }

        public Criteria andFatherIsNull() {
            addCriterion("Father is null");
            return (Criteria) this;
        }

        public Criteria andFatherIsNotNull() {
            addCriterion("Father is not null");
            return (Criteria) this;
        }

        public Criteria andFatherEqualTo(String value) {
            addCriterion("Father =", value, "father");
            return (Criteria) this;
        }

        public Criteria andFatherNotEqualTo(String value) {
            addCriterion("Father <>", value, "father");
            return (Criteria) this;
        }

        public Criteria andFatherGreaterThan(String value) {
            addCriterion("Father >", value, "father");
            return (Criteria) this;
        }

        public Criteria andFatherGreaterThanOrEqualTo(String value) {
            addCriterion("Father >=", value, "father");
            return (Criteria) this;
        }

        public Criteria andFatherLessThan(String value) {
            addCriterion("Father <", value, "father");
            return (Criteria) this;
        }

        public Criteria andFatherLessThanOrEqualTo(String value) {
            addCriterion("Father <=", value, "father");
            return (Criteria) this;
        }

        public Criteria andFatherLike(String value) {
            addCriterion("Father like", value, "father");
            return (Criteria) this;
        }

        public Criteria andFatherNotLike(String value) {
            addCriterion("Father not like", value, "father");
            return (Criteria) this;
        }

        public Criteria andFatherIn(List<String> values) {
            addCriterion("Father in", values, "father");
            return (Criteria) this;
        }

        public Criteria andFatherNotIn(List<String> values) {
            addCriterion("Father not in", values, "father");
            return (Criteria) this;
        }

        public Criteria andFatherBetween(String value1, String value2) {
            addCriterion("Father between", value1, value2, "father");
            return (Criteria) this;
        }

        public Criteria andFatherNotBetween(String value1, String value2) {
            addCriterion("Father not between", value1, value2, "father");
            return (Criteria) this;
        }

        public Criteria andFathersIsNull() {
            addCriterion("Fathers is null");
            return (Criteria) this;
        }

        public Criteria andFathersIsNotNull() {
            addCriterion("Fathers is not null");
            return (Criteria) this;
        }

        public Criteria andFathersEqualTo(String value) {
            addCriterion("Fathers =", value, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersNotEqualTo(String value) {
            addCriterion("Fathers <>", value, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersGreaterThan(String value) {
            addCriterion("Fathers >", value, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersGreaterThanOrEqualTo(String value) {
            addCriterion("Fathers >=", value, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersLessThan(String value) {
            addCriterion("Fathers <", value, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersLessThanOrEqualTo(String value) {
            addCriterion("Fathers <=", value, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersLike(String value) {
            addCriterion("Fathers like", value, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersNotLike(String value) {
            addCriterion("Fathers not like", value, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersIn(List<String> values) {
            addCriterion("Fathers in", values, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersNotIn(List<String> values) {
            addCriterion("Fathers not in", values, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersBetween(String value1, String value2) {
            addCriterion("Fathers between", value1, value2, "fathers");
            return (Criteria) this;
        }

        public Criteria andFathersNotBetween(String value1, String value2) {
            addCriterion("Fathers not between", value1, value2, "fathers");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andMobtelIsNull() {
            addCriterion("MobTel is null");
            return (Criteria) this;
        }

        public Criteria andMobtelIsNotNull() {
            addCriterion("MobTel is not null");
            return (Criteria) this;
        }

        public Criteria andMobtelEqualTo(String value) {
            addCriterion("MobTel =", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotEqualTo(String value) {
            addCriterion("MobTel <>", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelGreaterThan(String value) {
            addCriterion("MobTel >", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelGreaterThanOrEqualTo(String value) {
            addCriterion("MobTel >=", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLessThan(String value) {
            addCriterion("MobTel <", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLessThanOrEqualTo(String value) {
            addCriterion("MobTel <=", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLike(String value) {
            addCriterion("MobTel like", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotLike(String value) {
            addCriterion("MobTel not like", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelIn(List<String> values) {
            addCriterion("MobTel in", values, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotIn(List<String> values) {
            addCriterion("MobTel not in", values, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelBetween(String value1, String value2) {
            addCriterion("MobTel between", value1, value2, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotBetween(String value1, String value2) {
            addCriterion("MobTel not between", value1, value2, "mobtel");
            return (Criteria) this;
        }

        public Criteria andPointmodeIsNull() {
            addCriterion("PointMode is null");
            return (Criteria) this;
        }

        public Criteria andPointmodeIsNotNull() {
            addCriterion("PointMode is not null");
            return (Criteria) this;
        }

        public Criteria andPointmodeEqualTo(String value) {
            addCriterion("PointMode =", value, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeNotEqualTo(String value) {
            addCriterion("PointMode <>", value, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeGreaterThan(String value) {
            addCriterion("PointMode >", value, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeGreaterThanOrEqualTo(String value) {
            addCriterion("PointMode >=", value, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeLessThan(String value) {
            addCriterion("PointMode <", value, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeLessThanOrEqualTo(String value) {
            addCriterion("PointMode <=", value, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeLike(String value) {
            addCriterion("PointMode like", value, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeNotLike(String value) {
            addCriterion("PointMode not like", value, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeIn(List<String> values) {
            addCriterion("PointMode in", values, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeNotIn(List<String> values) {
            addCriterion("PointMode not in", values, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeBetween(String value1, String value2) {
            addCriterion("PointMode between", value1, value2, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPointmodeNotBetween(String value1, String value2) {
            addCriterion("PointMode not between", value1, value2, "pointmode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeIsNull() {
            addCriterion("PrepayMode is null");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeIsNotNull() {
            addCriterion("PrepayMode is not null");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeEqualTo(String value) {
            addCriterion("PrepayMode =", value, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeNotEqualTo(String value) {
            addCriterion("PrepayMode <>", value, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeGreaterThan(String value) {
            addCriterion("PrepayMode >", value, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeGreaterThanOrEqualTo(String value) {
            addCriterion("PrepayMode >=", value, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeLessThan(String value) {
            addCriterion("PrepayMode <", value, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeLessThanOrEqualTo(String value) {
            addCriterion("PrepayMode <=", value, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeLike(String value) {
            addCriterion("PrepayMode like", value, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeNotLike(String value) {
            addCriterion("PrepayMode not like", value, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeIn(List<String> values) {
            addCriterion("PrepayMode in", values, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeNotIn(List<String> values) {
            addCriterion("PrepayMode not in", values, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeBetween(String value1, String value2) {
            addCriterion("PrepayMode between", value1, value2, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andPrepaymodeNotBetween(String value1, String value2) {
            addCriterion("PrepayMode not between", value1, value2, "prepaymode");
            return (Criteria) this;
        }

        public Criteria andMessagesIsNull() {
            addCriterion("Messages is null");
            return (Criteria) this;
        }

        public Criteria andMessagesIsNotNull() {
            addCriterion("Messages is not null");
            return (Criteria) this;
        }

        public Criteria andMessagesEqualTo(String value) {
            addCriterion("Messages =", value, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesNotEqualTo(String value) {
            addCriterion("Messages <>", value, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesGreaterThan(String value) {
            addCriterion("Messages >", value, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesGreaterThanOrEqualTo(String value) {
            addCriterion("Messages >=", value, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesLessThan(String value) {
            addCriterion("Messages <", value, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesLessThanOrEqualTo(String value) {
            addCriterion("Messages <=", value, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesLike(String value) {
            addCriterion("Messages like", value, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesNotLike(String value) {
            addCriterion("Messages not like", value, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesIn(List<String> values) {
            addCriterion("Messages in", values, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesNotIn(List<String> values) {
            addCriterion("Messages not in", values, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesBetween(String value1, String value2) {
            addCriterion("Messages between", value1, value2, "messages");
            return (Criteria) this;
        }

        public Criteria andMessagesNotBetween(String value1, String value2) {
            addCriterion("Messages not between", value1, value2, "messages");
            return (Criteria) this;
        }

        public Criteria andBegindateIsNull() {
            addCriterion("BeginDate is null");
            return (Criteria) this;
        }

        public Criteria andBegindateIsNotNull() {
            addCriterion("BeginDate is not null");
            return (Criteria) this;
        }

        public Criteria andBegindateEqualTo(Date value) {
            addCriterion("BeginDate =", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotEqualTo(Date value) {
            addCriterion("BeginDate <>", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateGreaterThan(Date value) {
            addCriterion("BeginDate >", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateGreaterThanOrEqualTo(Date value) {
            addCriterion("BeginDate >=", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateLessThan(Date value) {
            addCriterion("BeginDate <", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateLessThanOrEqualTo(Date value) {
            addCriterion("BeginDate <=", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateIn(List<Date> values) {
            addCriterion("BeginDate in", values, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotIn(List<Date> values) {
            addCriterion("BeginDate not in", values, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateBetween(Date value1, Date value2) {
            addCriterion("BeginDate between", value1, value2, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotBetween(Date value1, Date value2) {
            addCriterion("BeginDate not between", value1, value2, "begindate");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNull() {
            addCriterion("EndDate is null");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNotNull() {
            addCriterion("EndDate is not null");
            return (Criteria) this;
        }

        public Criteria andEnddateEqualTo(Date value) {
            addCriterion("EndDate =", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotEqualTo(Date value) {
            addCriterion("EndDate <>", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThan(Date value) {
            addCriterion("EndDate >", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThanOrEqualTo(Date value) {
            addCriterion("EndDate >=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThan(Date value) {
            addCriterion("EndDate <", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThanOrEqualTo(Date value) {
            addCriterion("EndDate <=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateIn(List<Date> values) {
            addCriterion("EndDate in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotIn(List<Date> values) {
            addCriterion("EndDate not in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateBetween(Date value1, Date value2) {
            addCriterion("EndDate between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotBetween(Date value1, Date value2) {
            addCriterion("EndDate not between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andMonfeeIsNull() {
            addCriterion("MonFee is null");
            return (Criteria) this;
        }

        public Criteria andMonfeeIsNotNull() {
            addCriterion("MonFee is not null");
            return (Criteria) this;
        }

        public Criteria andMonfeeEqualTo(Integer value) {
            addCriterion("MonFee =", value, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeNotEqualTo(Integer value) {
            addCriterion("MonFee <>", value, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeGreaterThan(Integer value) {
            addCriterion("MonFee >", value, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("MonFee >=", value, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeLessThan(Integer value) {
            addCriterion("MonFee <", value, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeLessThanOrEqualTo(Integer value) {
            addCriterion("MonFee <=", value, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeIn(List<Integer> values) {
            addCriterion("MonFee in", values, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeNotIn(List<Integer> values) {
            addCriterion("MonFee not in", values, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeBetween(Integer value1, Integer value2) {
            addCriterion("MonFee between", value1, value2, "monfee");
            return (Criteria) this;
        }

        public Criteria andMonfeeNotBetween(Integer value1, Integer value2) {
            addCriterion("MonFee not between", value1, value2, "monfee");
            return (Criteria) this;
        }

        public Criteria andMaxloginIsNull() {
            addCriterion("MaxLogIn is null");
            return (Criteria) this;
        }

        public Criteria andMaxloginIsNotNull() {
            addCriterion("MaxLogIn is not null");
            return (Criteria) this;
        }

        public Criteria andMaxloginEqualTo(Integer value) {
            addCriterion("MaxLogIn =", value, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginNotEqualTo(Integer value) {
            addCriterion("MaxLogIn <>", value, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginGreaterThan(Integer value) {
            addCriterion("MaxLogIn >", value, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginGreaterThanOrEqualTo(Integer value) {
            addCriterion("MaxLogIn >=", value, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginLessThan(Integer value) {
            addCriterion("MaxLogIn <", value, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginLessThanOrEqualTo(Integer value) {
            addCriterion("MaxLogIn <=", value, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginIn(List<Integer> values) {
            addCriterion("MaxLogIn in", values, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginNotIn(List<Integer> values) {
            addCriterion("MaxLogIn not in", values, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginBetween(Integer value1, Integer value2) {
            addCriterion("MaxLogIn between", value1, value2, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andMaxloginNotBetween(Integer value1, Integer value2) {
            addCriterion("MaxLogIn not between", value1, value2, "maxlogin");
            return (Criteria) this;
        }

        public Criteria andLoginIsNull() {
            addCriterion("LogIn is null");
            return (Criteria) this;
        }

        public Criteria andLoginIsNotNull() {
            addCriterion("LogIn is not null");
            return (Criteria) this;
        }

        public Criteria andLoginEqualTo(Integer value) {
            addCriterion("LogIn =", value, "login");
            return (Criteria) this;
        }

        public Criteria andLoginNotEqualTo(Integer value) {
            addCriterion("LogIn <>", value, "login");
            return (Criteria) this;
        }

        public Criteria andLoginGreaterThan(Integer value) {
            addCriterion("LogIn >", value, "login");
            return (Criteria) this;
        }

        public Criteria andLoginGreaterThanOrEqualTo(Integer value) {
            addCriterion("LogIn >=", value, "login");
            return (Criteria) this;
        }

        public Criteria andLoginLessThan(Integer value) {
            addCriterion("LogIn <", value, "login");
            return (Criteria) this;
        }

        public Criteria andLoginLessThanOrEqualTo(Integer value) {
            addCriterion("LogIn <=", value, "login");
            return (Criteria) this;
        }

        public Criteria andLoginIn(List<Integer> values) {
            addCriterion("LogIn in", values, "login");
            return (Criteria) this;
        }

        public Criteria andLoginNotIn(List<Integer> values) {
            addCriterion("LogIn not in", values, "login");
            return (Criteria) this;
        }

        public Criteria andLoginBetween(Integer value1, Integer value2) {
            addCriterion("LogIn between", value1, value2, "login");
            return (Criteria) this;
        }

        public Criteria andLoginNotBetween(Integer value1, Integer value2) {
            addCriterion("LogIn not between", value1, value2, "login");
            return (Criteria) this;
        }

        public Criteria andLocationidIsNull() {
            addCriterion("LocationID is null");
            return (Criteria) this;
        }

        public Criteria andLocationidIsNotNull() {
            addCriterion("LocationID is not null");
            return (Criteria) this;
        }

        public Criteria andLocationidEqualTo(String value) {
            addCriterion("LocationID =", value, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidNotEqualTo(String value) {
            addCriterion("LocationID <>", value, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidGreaterThan(String value) {
            addCriterion("LocationID >", value, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidGreaterThanOrEqualTo(String value) {
            addCriterion("LocationID >=", value, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidLessThan(String value) {
            addCriterion("LocationID <", value, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidLessThanOrEqualTo(String value) {
            addCriterion("LocationID <=", value, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidLike(String value) {
            addCriterion("LocationID like", value, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidNotLike(String value) {
            addCriterion("LocationID not like", value, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidIn(List<String> values) {
            addCriterion("LocationID in", values, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidNotIn(List<String> values) {
            addCriterion("LocationID not in", values, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidBetween(String value1, String value2) {
            addCriterion("LocationID between", value1, value2, "locationid");
            return (Criteria) this;
        }

        public Criteria andLocationidNotBetween(String value1, String value2) {
            addCriterion("LocationID not between", value1, value2, "locationid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}